package com.suns.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.suns.domain.Income;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;

@Mapper
public interface IncomeDao extends BaseMapper<Income> {
//    @Select("SELECT SUM(money) FROM income WHERE DATE_FORMAT(time, '%Y-%m-%d') = #{day} AND usertype = #{usertype}")
//    BigDecimal sumMoneyByDate(@Param("day") String day,@Param("usertype") String usertype);
}
